﻿<%@ Page Language="vb" ContentType ="text/xml" AutoEventWireup="false" CodeBehind="WuggiRSS.aspx.vb" Inherits="WuggiSum.WuggiRSS" %>


        <asp:SqlDataSource ID="WugSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            
            SelectCommand="SELECT a.[m_id], a.[m_title], a.[m_desc], a.[m_poster], a.[m_pg], a.[m_year], b.[s_genre] FROM [movies] a , [subgenre] b where a.[sub_id] = b.[sub_id]">
        </asp:SqlDataSource>
       
        <asp:Repeater ID="WuggiRepeat" runat="server" DataSourceID="WugSource">
          <HeaderTemplate>
            <rss version="2.0">
              <channel>
                    <title> Drama Movies </title>
                    <description> London Areas </description>
</HeaderTemplate>
<ItemTemplate>
               <item>
                    <title><%# XMLFormat(DataBinder.Eval(Container.DataItem, "m_title"))%></title>
                    <description><%# XMLFormat(DataBinder.Eval(Container.DataItem, "m_desc"))%></description>
                    <link> Details.aspx?WuggiQuery=<%# XMLFormat(DataBinder.Eval(Container.DataItem, "m_id"))%></link><author><%# XMLFormat(DataBinder.Eval(Container.DataItem, "m_poster"))%></author>
                    <pubDate><%# XMLFormat(DataBinder.Eval(Container.DataItem, "m_year"))%></pubDate>
               </item>
</ItemTemplate>
<FooterTemplate>
            </channel>
            </rss>
</FooterTemplate>
</asp:Repeater>



